package com.boho.ecp.manage.service.param.dao;

import java.sql.Connection;

import cn.boho.framework.po.CQuery;
import cn.boho.framework.po.CQueryFactoryTool;
import cn.boho.framework.po.DAO;
import cn.boho.framework.po.DynaBeanMap;

public class ParamDao extends DAO{

	public static DynaBeanMap getParamByName(Connection con, String paramName) throws Exception{
		DynaBeanMap dbm = null;
		StringBuffer sql = new StringBuffer();
		sql.append("select * from T_SYSTEM_PARA where IS_VALID = 1 and SYSTEM_PARA_DESC = ?");
		CQuery query = CQueryFactoryTool.createFactory().createCQuery();
		query.setString(1, paramName);
		query.setCommand(sql.toString());
		return query.getDynaBeanMap("T_SYSTEM_PARA", con);
	}
	
}
